﻿CREATE TABLE [dbo].[PatternDescription]
(
	[Id] BIGINT NOT NULL IDENTITY(1,1) PRIMARY KEY,
	[Name] NVARCHAR(50) NOT NULL,
	[IconUrl] NVARCHAR(2000) NOT NULL,
	[PatternDescriptionGroupId] BIGINT NOT NULL,
	CONSTRAINT [UQ_PatternDescription_Name] UNIQUE ([Name]),
	CONSTRAINT [FK_PatternDescription_Group] FOREIGN KEY ([PatternDescriptionGroupId])
		REFERENCES [dbo].[PatternDescriptionGroup] ([Id]) ON UPDATE NO ACTION ON DELETE CASCADE
)
